IF OBJECT_ID('ssf.dpnd_get_parameter_dependency') IS NOT NULL
	DROP FUNCTION ssf.dpnd_get_parameter_dependency
GO

CREATE FUNCTION ssf.dpnd_get_parameter_dependency (
	@dpnd_object_name NVARCHAR(256)
)
RETURNS TABLE
AS
	RETURN (
		SELECT parameter_id
			, header_object_id
			, parameter_order
			, parameter_name
			, parameter_desc
			, data_type
			, default_value
			, return_type
		FROM ssf.dpnd_header_parameter WITH (NOLOCK)
		WHERE header_object_id = ssf.dpnd_get_header_object_id(@dpnd_object_name)
	)
GO
